Run SQL Interactively in Revealjs Presentation Made with Quarto
last-modified
Here we will use a sample Database called HR that manages the HR data of the small businesses which is collected from www.sqltutorial.org. And to create the database, a SQLite script file was used when rendering the document. Read the extension docs for details.
The following database diagram illustrates the HR sample database:
Figure 1: ERD of HR database
And now, you can run all sort of queries from the tables of the HR databases.
You can also create “not-editable” code chunk (that is, you simply can run the query but won’t be able to edit/modify it) for HR database. And to do this, just use another instance of database under the database key in the yaml with a different name and use the option editable: false.
Welcome to a demo RevealJS presentation that uses the quarto-webr extension to generate interactive code cells with Quarto and webR.
Important
This template requires a pre-release version of Quarto that is 1.4.502 or greater that contains an updated copy of pandoc. For more details, please see Issue #14.
Not the right template? Let’s go back to the documentation portal
This is a webR-enabled code cell in a Quarto RevealJS document.
You can embed the slide deck inside of a Quarto Website or Book by using:
<style>
.slide-deck {
border: 3px solid #dee2e6;
width: 100%;
height: 475px;
}
</style>
<div>
```{=html}
<iframe class="slide-deck" src="path/to/presentation/"></iframe>
```
</div>Note
Avoid using within a RevealJS presentation. Only 1 instance of webR should be running.
Thanks for checking out the demo! Let’s head back to the documentation portal.
Welcome to a demo RevealJS presentation that uses the quarto-pyodide extension to generate interactive code cells with Quarto and Pyodide.
Not the right template? Let’s go back to the documentation portal
This is a Pyodide-enabled code cell in a Quarto HTML document.
Pair code cells with a countdown timer to allow for practice
{{< countdown 00:05 top=0 >}}Fill in the following function to say hi!
Thanks for checking out the demo! Let’s head back to the documentation portal.